select boa.recordTime as recordTime,
       boa.happenTime as happenTime,
       accSub.fullName as fullName,
       accSub.subjectCode as subjectCode,
       boa.direction as direction,
       boa.money as money,
       boa.notes as notes
from BookOfAccountBoImpl boa, AccountSubjectBoImpl accSub
where boa.accountSubject = accSub.accountSubjectId 
      and boa.money>0
      and boa.happenTime>=?
      and boa.happenTime<=?
order by boa.recordTime,accSub.subjectCode